1 <?php
2 require("../includes/config.php");
3 include("../includes/validate_data.php");
4 error_reporting(0);
5 session_start();
6 if(isset($_SESSION['admin_login'])) {
7 $error = "";
8 $querySelectRetailer = "SELECT *,area.area_id AS area_id FROM retailer,area WHERE retailer.area_id = area.area_id";
9 $resultSelectRetailer = mysqli_query($con,$querySelectRetailer);
10 if($_SERVER['REQUEST_METHOD'] == "POST") {
11 if(isset($_POST['cmbFilter'])) {
12 if(!empty($_POST['txtId'])) {
13 $result = validate_number($_POST['txtId']);
14 if($result == 1) {
15 $order_id = $_POST['txtId'];
16 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND order_id='$order_id'";
17 $result_selectOrder = mysqli_query($con,$query_selectOrder);
18 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
19 if(empty($row_selectOrder)){
20 $error = "* No order was found with this ID";
21 }
22 else {
23 mysqli_data_seek($result_selectOrder,0);
24 }
25 }
26 else {
27 $error = "* Invalid ID";
28 }
29 }
30 else if(!empty($_POST['cmbRetailer'])) {
31 $retailer_id = $_POST['cmbRetailer'];
32 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND orders.retailer_id='$retailer_id' ORDER BY approved,status,order_id DESC";
33 $result_selectOrder = mysqli_query($con,$query_selectOrder);
34 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
35 if(empty($row_selectOrder)){
36 $error = "* No order was found of the selected Retailer";
37 }
38 else {
39 mysqli_data_seek($result_selectOrder,0);
40 }
41 }
42 else if(!empty($_POST['txtDate'])) {
43 $date = $_POST['txtDate'];
44 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND date='$date'";
45 $result_selectOrder = mysqli_query($con,$query_selectOrder);
46 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
47 if(empty($row_selectOrder)){
48 $error = "* No order was found with the selected Date";
49 }
50 else {
51 mysqli_data_seek($result_selectOrder,0);
52 }
53
54 }
55 else if(!empty($_POST['cmbStatus'])) {
56 if($_POST['cmbStatus'] == "zero") {
57 $status = 0;
58 }
59 else {
60 $status = $_POST['cmbStatus'];
61 }
62 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND status='$status' ORDER BY approved,order_id DESC";
63 $result_selectOrder = mysqli_query($con,$query_selectOrder);
64 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
65 if(empty($row_selectOrder)){
66 $error = "* No order was found";
67 }
68 else {
69 mysqli_data_seek($result_selectOrder,0);
70 }
71 }
72 else if(!empty($_POST['cmbApproved'])) {
73 if($_POST['cmbApproved'] == "zero") {
74 $approved = 0;
75 }
76 else {
77 $approved = $_POST['cmbApproved'];
78 }
79 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND approved='$approved' ORDER BY order_id DESC";
80 $result_selectOrder = mysqli_query($con,$query_selectOrder);
81 $row_selectOrder = mysqli_fetch_array($result_selectOrder);
82 if(empty($row_selectOrder)){
83 $error = "* No order was found";
84 }
85 else {
86 mysqli_data_seek($result_selectOrder,0);
87 }
88 }
89 else {
90 $error = "* Please enter the data to search for.";
91 }
92 }
93 else {
94 $error = "Please choose an option to search for.";
95 }
96 }
97 else {
98 $query_selectOrder = "SELECT * FROM orders,retailer,area WHERE orders.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id ORDER BY approved,status,order_id DESC;";
99 $result_selectOrder = mysqli_query($con,$query_selectOrder);
100 }
101 }
102 else {
103 header('Location:../index.php');
104 }
105 ?>
106
107 <!DOCTYPE html>
108 <html>
109 <head>
110 <title> View Orders </title>
111 <link rel="stylesheet" href="../includes/main_style.css" >
112 <link rel="stylesheet" href="css/smoothness/jquery-ui.css">
113 <script type="text/javascript" src="../includes/jquery.js"> </script>
114 <script src="js/jquery-ui.js"></script>
115 <script>
116 $(function() {
117 $( "#datepicker" ).datepicker({
118 changeMonth:true,
119 changeYear:true,
120 yearRange:"-100:+0",
121 dateFormat:"yy-mm-dd"
122 });
123 });
124 </script>
125 </head>
126 <body>
127 <?php
128 include("../includes/header.inc.php");
129 include("../includes/nav_admin.inc.php");
130 include("../includes/aside_admin.inc.php");
131 ?>
132 <section>
133 <h1>Orders</h1>
134 <form action="" method="POST" class="form">
135 Search By:
136 <div class="input-box">
137 <select name="cmbFilter" id="cmbFilter">
138 <option value="" disabled selected>-- Search By --</option>
139 <option value="id"> Id </option>
140 <option value="retailer"> Retailer </option>
141 <option value="date"> Date </option>
142 <option value="status"> Status </option>
143 <option value="approved"> Approval </option>
144 </select>
145 </div>
146
147 <div class="input-box"> <input type="text" name="txtId" id="txtId" style="display:none;" /> </div>
148 <div class="input-box">
149 <select name="cmbRetailer" id="cmbRetailer" style="display:none;">
150 <option value="" disabled selected>-- Select Retailer --</option>
151 <?php while($rowSelectRetailer = mysqli_fetch_array($resultSelectRetailer)) { ?>
152 <option value="<?php echo $rowSelectRetailer['retailer_id']; ?>"><?php echo $rowSelectRetailer['area_code']." (".$rowSelectRetailer['area_name'].")"; ?></option>
153 <?php } ?>
154 </select>
155 </div>
156 <div class="input-box"> <input type="text" id="datepicker" name="txtDate" style="display:none;"/> </div>
157 <div class="input-box">
158 <select name="cmbStatus" id="cmbStatus" style="display:none;">
159 <option value="" disabled selected>-- Select Option --</option>
160 <option value="zero"> Pending </option>
161 <option value="1"> Completed </option>
162 </select>
163 </div>
164 <div class="input-box">
165 <select name="cmbApproved" id="cmbApproved" style="display:none;">
166 <option value="" disabled selected>-- Select Option --</option>
167 <option value="zero"> Not Approved </option>
168 <option value="1"> Approved </option>
169 </select>
170 </div>
171
172 <input type="submit" class="submit_button" value="Search" /> <span class="error_message"> <?php echo $error; ?> </span>
173 </form>
174 <form action="" method="POST" class="form">
175 <table class="table_displayData" style="margin-top:20px;">
176 <tr>
177 <th> Order ID </th>
178 <th> Retailer </th>
179 <th> Date </th>
180 <th> Approved Status </th>
181 <th> Order Status </th>
182 <th> Details </th>
183 </tr>
184 <?php $i=1; while($row_selectOrder = mysqli_fetch_array($result_selectOrder)) { ?>
185 <tr>
186
187 <td> <?php echo $row_selectOrder['order_id']; ?> </td>
188 <td> <?php echo $row_selectOrder['area_code']; ?> </td>
189
190 <td> <?php echo date("d-m-Y",strtotime($row_selectOrder['date'])); ?> </td>
191 <td>
192 <?php
193 if($row_selectOrder['approved'] == 0) {
194 echo "Not Approved";
195 }
196 else {
197 echo "Approved";
198 }
199 ?>
200 </td>
201 <td>
202 <?php
203 if($row_selectOrder['status'] == 0) {
204 echo "Pending";
205 }
206 else {
207 echo "Completed";
208 }
209 ?>
210 </td>
211 <td> <a href="view_order_items.php?id=<?php echo $row_selectOrder['order_id']; ?>">Details</a> </td>
212 </tr>
213 <?php $i++; } ?>
214 </table>
215 </form>
216 </section>
217 <?php
218 include("../includes/footer.inc.php");
219 ?>
220 <script type="text/javascript">
221 $('#cmbFilter').change(function() {
222 var selected = $(this).val();
223 if(selected == "id"){
224 $('#txtId').show();
225 $('#cmbRetailer').hide();
226 $('#datepicker').hide();
227 $('#cmbStatus').hide();
228 $('#cmbApproved').hide();
229 }
230 else if (selected == "retailer"){
231 $('#txtId').hide();
232 $('#cmbRetailer').show();
233 $('#datepicker').hide();
234 $('#cmbStatus').hide();
235 $('#cmbApproved').hide();
236 }
237 else if (selected == "date"){
238 $('#txtId').hide();
239 $('#cmbRetailer').hide();
240 $('#datepicker').show();
241 $('#cmbStatus').hide();
242 $('#cmbApproved').hide();
243 }
244 else if (selected == "status"){
245 $('#txtId').hide();
246 $('#cmbRetailer').hide();
247 $('#datepicker').hide();
248 $('#cmbStatus').show();
249 $('#cmbApproved').hide();
250 }
251 else if (selected == "approved"){
252 $('#txtId').hide();
253 $('#cmbRetailer').hide();
254 $('#datepicker').hide();
255 $('#cmbStatus').hide();
256 $('#cmbApproved').show();
257 }
258 });
259 </script>
260 </body>
261 </html>